Parse Date
The Parse Date algorithm is to convert specified string data to equivalent date and time. For instance, we usually need to parse to a DateTime object to perform some operations like date difference, weekday, month name, formatting and so on.
The table below provides some examples of this date format conversion.
Source Column | Target Column |
---|---|
7-Jun-2013 | 06/07/2013 |
Fri, June 7 2013 | 06/07/2013 |
Note: You should specify information about how the dates and times are represented as text using the Input Format field, so that the algorithm can read a date from a string.
To configure this manipulate step, follow the instructions below:
- In the Admin Navigation tree, select Interfaces > InterfaceName > Tasks > TaskName > Steps.
- On the toolbar, click New >New Manipulate Step.

Creating a New Manipulate Step
- Navigate to the Dates section and select Parse Date.

Dates Section
- In the Parse Date work area, fill in the following fields:

Fields | Description |
---|---|
Name |
Provide a distinctive name for this step. |
Is Active |
Select the check box to engage the scheduler for this step. |
Order of Execution |
Enter the order in which this step should be executed. |
Filter Expression |
Optional. Use this filed to filter data from the source database prior to inserting it into the Schema table. |
Sort Expression |
Optional. Use this field to sort data from the source database prior to inserting it into the Schema table. |
Stop interface execution if query failed |
Optional. If enabled, the system will stop any data manipulation if the query returns an error. |
Save Schema (enabled per interface) |
If selected, the schema is created for this step. |
Source Column |
Select the column where you will retrieve the data source. |
Input Format |
Specify the pattern the source string value should match. For details on the pattern syntax, see Formatting Dates and Times. |
Target Column |
Select the column where you will get the converted value. |
Output Format |
Specify the pattern the output date/time value should match. For details on the pattern syntax, see Formatting Dates and Times. |
- Click the Save button.